[dbo].[asi_DocumentPathByHierarchyKey]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_DocumentPathByHierarchyKey

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@hierarchyKey	uniqueidentifier	16
@publishedOnly	bit	1

-- Given a HierarchyKey returns the full path to the document starting with the root name.  The path is in
-- slash notation.  Like $/Common/Business Objects/DocumentType
CREATE PROCEDURE [dbo].[asi_DocumentPathByHierarchyKey]
   @hierarchyKey uniqueidentifier,
   @publishedOnly bit = 0
AS
BEGIN
DECLARE
   @path nvarchar(4000)

   EXEC asi_DocumentPathByHierarchyKeyOut @hierarchyKey, @path OUT, 0, @publishedOnly

   SELECT @path AS Path
END

GO